Using the Report Grid

The Report Grid is the default destination and results panel for the Data Explorer. It is easily customised to display the information that you need. It includes the:

  • Group Header Panel which allows you to group like data together
  • Results panel which displays the results of your query
  • Footer panel which displays the group totals and grand totals
  • Filter criteria panel which displays any filters that have been applied to the query.

Employee Queries

For all Data Explorer queries using Employee as the Query Type, you may use the Drill Down function. This means that you can double click on each employee (i.e. anywhere on the employee line) to open their Employee Details screen.

Note that although the query result will include all relevant employees from all your companies, the drill down function is active for employees of the current company only. An 'Access Denied' message is displayed if you double click on a line for an employee within another company (i.e. not the current company).

Customising the Report Grid:

Adding and Removing Columns:

  1. Set up your query by selecting the query type, selections and criteria.
  2. Select Report Grid as your destination.
  3. Click on the Field Chooser icon in the toolbar
    The Customisation screen will appear giving you a list of customised fields that you can choose from.
  4. Click on the field/s that you wish to add to the report grid and, holding the left mouse button down, drag it up to the position that you require it in the headers. Repeat this for all the fields you wish to add.
  5. You can now remove any unwanted columns by clicking on the field in the headers and dragging it back into the Customisation screen.
  6. Click Run Query.

Grouping Columns:

The Query Types often have default groupings which will display in the Group Header Panel. You can add a further level of grouping if required:

  1. Set up and run your query
  2. Select the Header by which you want to group the data and drag it up into the Group Header Panel, positioning it at the level you want it to appear.
    For example you might want to group a Wage Analysis query by Company /Department/ Month. This would display wages data for a chosen company, divided up into the company departments. The data for each department would be divided into months.

Customising by right clicking on a header:

You can customise individual columns by right clicking on its header. When you do this a menu will pop up giving you several customisation options:

  • Sort Ascending/Descending which allows you sort the column either alphabetically or numerically depending on the content.
  • Clear Sorting which returns the data to its original order.
  • Group by this field which will group the entire report by the chosen field.
  • Group by Box which
  • Footer which toggles the footer panel on/off
  • Group Footers which groups the footer selections for comparison purposes
  • Remove this Column which removes the column from the grid
  • Field Chooser which opens the Customisation screen so that you can choose and add fields
  • Best Fit which will size the chosen column to the size of its widest entry
  • Best Fit (All Columns) which will size all columns to the size of the widest entry.

Customising by totalling columns:

You can total individual columns by right clicking on its footer. When you do this a menu will pop up giving you several options:

  • For a numerical column: Sum, min, max, count, average
  • For a string column: count

Return to the Data Explorer Desktop